package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.*;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_CompoundUniqueGroup({
        @_DDL_CompoundUnique(name = "k_mer_id_user_id", columns = {"mer_id", "mer_user_id"})
})
@_DDL_Table(name = "qb_acc", simpleName = "", engine = MysqlDriver.InnoDB, comment = "内部户账号")
public class _DDL_QbAcc {

    @_DDL_Primary()
    @_DDL_Column(name = "acc_id", type = SqlType.CHAR, size = 16, nullable = false, comment = "账号ID")
    private String id;

    @_DDL_Column(name = "acc_dis_name", type = SqlType.VARCHAR, size = 20, nullable = false, comment = "姓名")
    private String disName;

    @_DDL_Column(name = "acc_dis_phone", type = SqlType.VARCHAR, size = 20, nullable = false, comment = "证件类型")
    private String disPhone;

    @_DDL_Column(name = "acc_id_card_type", type = SqlType.VARCHAR, size = 10, nullable = false, comment = "类型")
    private String idCardType;

    @_DDL_Column(name = "acc_dis_id_card", type = SqlType.VARCHAR, size = 30, nullable = false, comment = "证件号码")
    private String disIdCard;

    @_DDL_Column(name = "mer_id", type = SqlType.VARCHAR, size = 30, nullable = false, comment = "商户号")
    private String merId;

    @_DDL_Column(name = "mer_user_id", type = SqlType.VARCHAR, size = 30, nullable = false, comment = "商户用户ID")
    private String merUserId;

    @_DDL_Column(name = "acc_state", type = SqlType.INT, comment = "状态，0：提交、1：成功、2：审核中、3：审核失败、4：审核成功、5：冻结、6：销毁")
    private Integer state;

    @_DDL_Column(name = "acc_fail_reason", type = SqlType.VARCHAR, size = 200, comment = "审核失败原因")
    private String failReason;

    @_DDL_Column(name = "cr_date", type = SqlType.DATETIME, nullable = false, comment = "创建时间")
    private java.time.LocalDateTime crDate;

    @_DDL_Index(name = "idx_up_date")
    @_DDL_Column(name = "up_date", type = SqlType.DATETIME, nullable = false, comment = "更新时间")
    private java.time.LocalDateTime upDate;

    @_DDL_Column(name = "acc_name", type = SqlType.VARCHAR, size = 50, nullable = false, comment = "姓名")
    private String name;

    @_DDL_Column(name = "acc_phone", type = SqlType.VARCHAR, size = 50, nullable = false, comment = "手机号")
    private String phone;

    @_DDL_Column(name = "acc_id_card", type = SqlType.VARCHAR, size = 100, nullable = false, comment = "证件号码")
    private String idCard;

    @_DDL_Column(name = "acc_img1", type = SqlType.CHAR, size = 32, comment = "证件照1")
    private String img1;

    @_DDL_Column(name = "acc_img2", type = SqlType.CHAR, size = 32, comment = "证件照2")
    private String img2;

}
